package com.xmx.mapper;

import com.xmx.entity.ServiceType;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import javax.xml.ws.Service;
import java.util.List;

public interface IServiceTypeMapper {
    //查询所有服务类型
    @Select("select * from serviceType")
    List<ServiceType> queryAllService();

    //添加新服务类型
    @Insert("insert into serviceType values(null,#{stname})")
    void addNewService(ServiceType service);

    //根据id删除
    @Delete("delete from serviceType where stid=#{stid}")
    void deleteServiceByid(Integer id);
}
